package vip.xiaonuo.smzq.modular.psba.mapper;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import vip.xiaonuo.smzq.modular.psba.entity.PsbaGtKjzycl;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
 * 评审备案—重叠范围内资源储量 Mapper
 *
 * @author sqq
 * @since 2024-05-22
 */
@Mapper
public interface PsbaGtKjzyclMapper extends BaseMapper<PsbaGtKjzycl> {
@Select("SELECT CONCAT(kslx, ',', kspj) AS kslxpj FROM psba_gt_kjzycl where psbabh=#{psbabh} GROUP BY kslxpj ")
    List<String> getKslxpjList(String psbabh);
@Select("SELECT zycllz FROM psba_gt_kjzycl where psbabh=#{psbabh} and kslx=#{kslx} and kspj=#{kspj} GROUP BY zycllz ")
    List<String> getZycllzList(@Param("psbabh") String psbabh,@Param("kslx") Integer kslx,@Param("kspj") Integer kspj);
}
